package com.company.cloud.admin.modules.admin.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.company.cloud.admin.modules.base.entity.PermissionInfo;

public interface PermissionQueryMapper {

	@Select("SELECT c.code AS code , c.type AS type , c.name AS name, c.show_name As showName," +
			"c.icon AS icon, c.url AS url,c.state AS state,c.orders AS orders," +
			" c.show_platform AS showPlatform, c.remark AS remark, " +
			"c.resource AS resource,c.parent_code  AS parentCode  " +
			"FROM pt_admin_user_role_info a " +
			"INNER JOIN pt_admin_role_permission_info  b ON (a.role_code=b.role_code) " +
			"INNER JOIN pt_admin_permission_info c  ON (b.per_code=c.code) ${ew.customSqlSegment}")
	public List<PermissionInfo> queryUserMenu(@Param(Constants.WRAPPER) Wrapper<PermissionInfo> wrapper);
	
	


	
}
